package com.wanbangee.marksystem.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.wanbangee.marksystem.entities.StatisticsScoreTarget;
@Mapper
public interface StatisticsScoreTargetDao {
	/**
	 * 根据考试ID和科目ID查询分数段指标表
	 * @param examId  
	 * @param subId
	 * @return
	 */
	public List<StatisticsScoreTarget> selectScoreSubsectionByExamIdAndSubId(@Param("examId")Integer examId,@Param("subId")Integer subId); 
	
	/**
	 * 根据考试ID和科目ID删除分数段指标表
	 * @param examId
	 * @param subId
	 */
	public int deleteScoreSubsectionByExamIdAndSubId(@Param("examId")Integer examId,@Param("subId")Integer subId); 
	
	/**
	 * 插入分数段指标表
	 * @param sct
	 */
	public int insertStatisticsScoreTarget(StatisticsScoreTarget sct);
}
